HI.,
I need to retrive the Top 10 , Top 25 commodities for that over all comodities in the filters based on the Weeks i selected..
Please help me.
NONEMPTY
( TOPCOUNT({ [Dim Commodity].[Hierarchy].Members},3,[Measures].[Teu]))
-----------------------------------------------------------------
NONEMPTY
( TOPCOUNT({ [Dim Commodity].[Hierarchy].[ALL] },3,[Measures].[Teu]))
How to get top 25, Top 10 for the given Date Difference based on measure.